﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="book_shopDataSet" targetNamespace="http://tempuri.org/book_shopDataSet.xsd" xmlns:mstns="http://tempuri.org/book_shopDataSet.xsd" xmlns="http://tempuri.org/book_shopDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="book_shopConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="book_shopConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.BookShopSample.Properties.Settings.GlobalReference.Default.book_shopConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="adressTableAdapter" GeneratorDataComponentClassName="adressTableAdapter" Name="adress" UserDataComponentName="adressTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="book_shopConnectionString (Settings)" DbObjectName="book_shop.dbo.adress" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[adress] WHERE (([id] = @Original_id) AND ((@IsNull_adress_line_1 = 1 AND [adress_line_1] IS NULL) OR ([adress_line_1] = @Original_adress_line_1)) AND ((@IsNull_adress_line_2 = 1 AND [adress_line_2] IS NULL) OR ([adress_line_2] = @Original_adress_line_2)) AND ([user_account_id] = @Original_user_account_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_adress_line_1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="adress_line_1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_adress_line_1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="adress_line_1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_adress_line_2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="adress_line_2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_adress_line_2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="adress_line_2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_user_account_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_account_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[adress] ([id], [adress_line_1], [adress_line_2], [user_account_id]) VALUES (@id, @adress_line_1, @adress_line_2, @user_account_id);
SELECT id, adress_line_1, adress_line_2, user_account_id FROM adress WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@adress_line_1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="adress_line_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@adress_line_2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="adress_line_2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_account_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_account_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, adress_line_1, adress_line_2, user_account_id FROM dbo.adress</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[adress] SET [id] = @id, [adress_line_1] = @adress_line_1, [adress_line_2] = @adress_line_2, [user_account_id] = @user_account_id WHERE (([id] = @Original_id) AND ((@IsNull_adress_line_1 = 1 AND [adress_line_1] IS NULL) OR ([adress_line_1] = @Original_adress_line_1)) AND ((@IsNull_adress_line_2 = 1 AND [adress_line_2] IS NULL) OR ([adress_line_2] = @Original_adress_line_2)) AND ([user_account_id] = @Original_user_account_id));
SELECT id, adress_line_1, adress_line_2, user_account_id FROM adress WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@adress_line_1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="adress_line_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@adress_line_2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="adress_line_2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_account_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_account_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_adress_line_1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="adress_line_1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_adress_line_1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="adress_line_1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_adress_line_2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="adress_line_2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_adress_line_2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="adress_line_2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_user_account_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_account_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="adress_line_1" DataSetColumn="adress_line_1" />
              <Mapping SourceColumn="adress_line_2" DataSetColumn="adress_line_2" />
              <Mapping SourceColumn="user_account_id" DataSetColumn="user_account_id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="authorTableAdapter" GeneratorDataComponentClassName="authorTableAdapter" Name="author" UserDataComponentName="authorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="book_shopConnectionString (Settings)" DbObjectName="book_shop.dbo.author" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[author] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[author] ([id], [name]) VALUES (@id, @name);
SELECT id, name FROM author WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, name FROM dbo.author</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[author] SET [id] = @id, [name] = @name WHERE (([id] = @Original_id));
SELECT id, name FROM author WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="bookTableAdapter" GeneratorDataComponentClassName="bookTableAdapter" Name="book" UserDataComponentName="bookTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="book_shopConnectionString (Settings)" DbObjectName="book_shop.dbo.book" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[book] WHERE (([id] = @Original_id) AND ([category_id] = @Original_category_id) AND ((@IsNull_price = 1 AND [price] IS NULL) OR ([price] = @Original_price)) AND ([publishing_hpuse_id] = @Original_publishing_hpuse_id) AND ((@IsNull_author_id = 1 AND [author_id] IS NULL) OR ([author_id] = @Original_author_id)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_category_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="category_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_publishing_hpuse_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="publishing_hpuse_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_author_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="author_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_author_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="author_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[book] ([id], [title], [category_id], [price], [description], [publishing_hpuse_id], [author_id]) VALUES (@id, @title, @category_id, @price, @description, @publishing_hpuse_id, @author_id);
SELECT id, title, category_id, price, description, publishing_hpuse_id, author_id FROM book WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@title" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@category_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="category_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@publishing_hpuse_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="publishing_hpuse_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@author_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="author_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, title, category_id, price, description, publishing_hpuse_id, author_id FROM dbo.book</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[book] SET [id] = @id, [title] = @title, [category_id] = @category_id, [price] = @price, [description] = @description, [publishing_hpuse_id] = @publishing_hpuse_id, [author_id] = @author_id WHERE (([id] = @Original_id) AND ([category_id] = @Original_category_id) AND ((@IsNull_price = 1 AND [price] IS NULL) OR ([price] = @Original_price)) AND ([publishing_hpuse_id] = @Original_publishing_hpuse_id) AND ((@IsNull_author_id = 1 AND [author_id] IS NULL) OR ([author_id] = @Original_author_id)));
SELECT id, title, category_id, price, description, publishing_hpuse_id, author_id FROM book WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@title" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@category_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="category_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@publishing_hpuse_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="publishing_hpuse_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@author_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="author_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_category_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="category_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_price" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_publishing_hpuse_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="publishing_hpuse_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_author_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="author_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_author_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="author_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
              <Mapping SourceColumn="category_id" DataSetColumn="category_id" />
              <Mapping SourceColumn="price" DataSetColumn="price" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="publishing_hpuse_id" DataSetColumn="publishing_hpuse_id" />
              <Mapping SourceColumn="author_id" DataSetColumn="author_id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="book_authorTableAdapter" GeneratorDataComponentClassName="book_authorTableAdapter" Name="book_author" UserDataComponentName="book_authorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="book_shopConnectionString (Settings)" DbObjectName="book_shop.dbo.book_author" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[book_author] ([author_id], [book_id]) VALUES (@author_id, @book_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@author_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="author_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@book_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="book_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT author_id, book_id FROM dbo.book_author</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="author_id" DataSetColumn="author_id" />
              <Mapping SourceColumn="book_id" DataSetColumn="book_id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="categoryTableAdapter" GeneratorDataComponentClassName="categoryTableAdapter" Name="category" UserDataComponentName="categoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="book_shopConnectionString (Settings)" DbObjectName="book_shop.dbo.category" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[category] WHERE (([id] = @Original_id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[category] ([id], [name]) VALUES (@id, @name);
SELECT id, name FROM category WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, name FROM dbo.category</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[category] SET [id] = @id, [name] = @name WHERE (([id] = @Original_id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)));
SELECT id, name FROM category WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CategoryBookTableAdapter" GeneratorDataComponentClassName="CategoryBookTableAdapter" Name="CategoryBook" UserDataComponentName="CategoryBookTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="book_shopConnectionString (Settings)" DbObjectName="book_shop.dbo.CategoryBook" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[CategoryBook] ([CategoryID], [BookID]) VALUES (@CategoryID, @BookID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BookID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BookID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CategoryID, BookID FROM dbo.CategoryBook</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
              <Mapping SourceColumn="BookID" DataSetColumn="BookID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="publishing_houseTableAdapter" GeneratorDataComponentClassName="publishing_houseTableAdapter" Name="publishing_house" UserDataComponentName="publishing_houseTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="book_shopConnectionString (Settings)" DbObjectName="book_shop.dbo.publishing_house" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[publishing_house] WHERE (([id] = @Original_id) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[publishing_house] ([id], [title]) VALUES (@id, @title);
SELECT id, title FROM publishing_house WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, title FROM dbo.publishing_house</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[publishing_house] SET [id] = @id, [title] = @title WHERE (([id] = @Original_id) AND ((@IsNull_title = 1 AND [title] IS NULL) OR ([title] = @Original_title)));
SELECT id, title FROM publishing_house WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="purchaseTableAdapter" GeneratorDataComponentClassName="purchaseTableAdapter" Name="purchase" UserDataComponentName="purchaseTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="book_shopConnectionString (Settings)" DbObjectName="book_shop.dbo.purchase" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[purchase] WHERE (([id] = @Original_id) AND ((@IsNull_purchase_date = 1 AND [purchase_date] IS NULL) OR ([purchase_date] = @Original_purchase_date)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_purchase_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="purchase_date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_purchase_date" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="purchase_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[purchase] ([id], [user_account_id], [delivery_adress_id], [total_prise]) VALUES (@id, @user_account_id, @delivery_adress_id, @total_prise);
SELECT id, purchase_date, user_account_id, delivery_adress_id, total_prise FROM purchase WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_account_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_account_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@delivery_adress_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="delivery_adress_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@total_prise" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="total_prise" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, purchase_date, user_account_id, delivery_adress_id, total_prise FROM dbo.purchase</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[purchase] SET [id] = @id, [user_account_id] = @user_account_id, [delivery_adress_id] = @delivery_adress_id, [total_prise] = @total_prise WHERE (([id] = @Original_id) AND ((@IsNull_purchase_date = 1 AND [purchase_date] IS NULL) OR ([purchase_date] = @Original_purchase_date)));
SELECT id, purchase_date, user_account_id, delivery_adress_id, total_prise FROM purchase WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_account_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_account_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@delivery_adress_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="delivery_adress_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@total_prise" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="total_prise" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_purchase_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="purchase_date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_purchase_date" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="purchase_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="purchase_date" DataSetColumn="purchase_date" />
              <Mapping SourceColumn="user_account_id" DataSetColumn="user_account_id" />
              <Mapping SourceColumn="delivery_adress_id" DataSetColumn="delivery_adress_id" />
              <Mapping SourceColumn="total_prise" DataSetColumn="total_prise" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="purchase_itemTableAdapter" GeneratorDataComponentClassName="purchase_itemTableAdapter" Name="purchase_item" UserDataComponentName="purchase_itemTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="book_shopConnectionString (Settings)" DbObjectName="book_shop.dbo.purchase_item" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[purchase_item] ([book_id], [purchase_id], [quantity], [items_prise]) VALUES (@book_id, @purchase_id, @quantity, @items_prise)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@book_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="book_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@purchase_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="purchase_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@quantity" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="quantity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@items_prise" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="items_prise" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT book_id, purchase_id, quantity, items_prise FROM dbo.purchase_item</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="book_id" DataSetColumn="book_id" />
              <Mapping SourceColumn="purchase_id" DataSetColumn="purchase_id" />
              <Mapping SourceColumn="quantity" DataSetColumn="quantity" />
              <Mapping SourceColumn="items_prise" DataSetColumn="items_prise" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="user_accountTableAdapter" GeneratorDataComponentClassName="user_accountTableAdapter" Name="user_account" UserDataComponentName="user_accountTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="book_shopConnectionString (Settings)" DbObjectName="book_shop.dbo.user_account" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[user_account] WHERE (([id] = @Original_id) AND ((@IsNull_user_name = 1 AND [user_name] IS NULL) OR ([user_name] = @Original_user_name)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)) AND ((@IsNull_password_salt = 1 AND [password_salt] IS NULL) OR ([password_salt] = @Original_password_salt)) AND ((@IsNull_password_hash_algorithm = 1 AND [password_hash_algorithm] IS NULL) OR ([password_hash_algorithm] = @Original_password_hash_algorithm)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password_salt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password_salt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password_salt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password_salt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password_hash_algorithm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password_hash_algorithm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password_hash_algorithm" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password_hash_algorithm" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[user_account] ([id], [user_name], [email], [password], [password_salt], [password_hash_algorithm]) VALUES (@id, @user_name, @email, @password, @password_salt, @password_hash_algorithm);
SELECT id, user_name, email, password, password_salt, password_hash_algorithm FROM user_account WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password_salt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password_salt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password_hash_algorithm" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password_hash_algorithm" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, user_name, email, password, password_salt, password_hash_algorithm FROM dbo.user_account</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[user_account] SET [id] = @id, [user_name] = @user_name, [email] = @email, [password] = @password, [password_salt] = @password_salt, [password_hash_algorithm] = @password_hash_algorithm WHERE (([id] = @Original_id) AND ((@IsNull_user_name = 1 AND [user_name] IS NULL) OR ([user_name] = @Original_user_name)) AND ((@IsNull_email = 1 AND [email] IS NULL) OR ([email] = @Original_email)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)) AND ((@IsNull_password_salt = 1 AND [password_salt] IS NULL) OR ([password_salt] = @Original_password_salt)) AND ((@IsNull_password_hash_algorithm = 1 AND [password_hash_algorithm] IS NULL) OR ([password_hash_algorithm] = @Original_password_hash_algorithm)));
SELECT id, user_name, email, password, password_salt, password_hash_algorithm FROM user_account WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@user_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password_salt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password_salt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password_hash_algorithm" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password_hash_algorithm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_user_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_user_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="user_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password_salt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password_salt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password_salt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password_salt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password_hash_algorithm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password_hash_algorithm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password_hash_algorithm" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password_hash_algorithm" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="user_name" DataSetColumn="user_name" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
              <Mapping SourceColumn="password_salt" DataSetColumn="password_salt" />
              <Mapping SourceColumn="password_hash_algorithm" DataSetColumn="password_hash_algorithm" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="book_shopDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="book_shopDataSet" msprop:Generator_UserDSName="book_shopDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="adress" msprop:Generator_TableClassName="adressDataTable" msprop:Generator_TableVarName="tableadress" msprop:Generator_TablePropName="adress" msprop:Generator_RowDeletingName="adressRowDeleting" msprop:Generator_RowChangingName="adressRowChanging" msprop:Generator_RowEvHandlerName="adressRowChangeEventHandler" msprop:Generator_RowDeletedName="adressRowDeleted" msprop:Generator_UserTableName="adress" msprop:Generator_RowChangedName="adressRowChanged" msprop:Generator_RowEvArgName="adressRowChangeEvent" msprop:Generator_RowClassName="adressRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="adress_line_1" msprop:Generator_ColumnVarNameInTable="columnadress_line_1" msprop:Generator_ColumnPropNameInRow="adress_line_1" msprop:Generator_ColumnPropNameInTable="adress_line_1Column" msprop:Generator_UserColumnName="adress_line_1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="adress_line_2" msprop:Generator_ColumnVarNameInTable="columnadress_line_2" msprop:Generator_ColumnPropNameInRow="adress_line_2" msprop:Generator_ColumnPropNameInTable="adress_line_2Column" msprop:Generator_UserColumnName="adress_line_2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_account_id" msprop:Generator_ColumnVarNameInTable="columnuser_account_id" msprop:Generator_ColumnPropNameInRow="user_account_id" msprop:Generator_ColumnPropNameInTable="user_account_idColumn" msprop:Generator_UserColumnName="user_account_id" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="author" msprop:Generator_TableClassName="authorDataTable" msprop:Generator_TableVarName="tableauthor" msprop:Generator_TablePropName="author" msprop:Generator_RowDeletingName="authorRowDeleting" msprop:Generator_RowChangingName="authorRowChanging" msprop:Generator_RowEvHandlerName="authorRowChangeEventHandler" msprop:Generator_RowDeletedName="authorRowDeleted" msprop:Generator_UserTableName="author" msprop:Generator_RowChangedName="authorRowChanged" msprop:Generator_RowEvArgName="authorRowChangeEvent" msprop:Generator_RowClassName="authorRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="book" msprop:Generator_TableClassName="bookDataTable" msprop:Generator_TableVarName="tablebook" msprop:Generator_TablePropName="book" msprop:Generator_RowDeletingName="bookRowDeleting" msprop:Generator_RowChangingName="bookRowChanging" msprop:Generator_RowEvHandlerName="bookRowChangeEventHandler" msprop:Generator_RowDeletedName="bookRowDeleted" msprop:Generator_UserTableName="book" msprop:Generator_RowChangedName="bookRowChanged" msprop:Generator_RowEvArgName="bookRowChangeEvent" msprop:Generator_RowClassName="bookRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_UserColumnName="title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="category_id" msprop:Generator_ColumnVarNameInTable="columncategory_id" msprop:Generator_ColumnPropNameInRow="category_id" msprop:Generator_ColumnPropNameInTable="category_idColumn" msprop:Generator_UserColumnName="category_id" type="xs:int" />
              <xs:element name="price" msprop:Generator_ColumnVarNameInTable="columnprice" msprop:Generator_ColumnPropNameInRow="price" msprop:Generator_ColumnPropNameInTable="priceColumn" msprop:Generator_UserColumnName="price" type="xs:decimal" minOccurs="0" />
              <xs:element name="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" msprop:Generator_UserColumnName="description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="publishing_hpuse_id" msprop:Generator_ColumnVarNameInTable="columnpublishing_hpuse_id" msprop:Generator_ColumnPropNameInRow="publishing_hpuse_id" msprop:Generator_ColumnPropNameInTable="publishing_hpuse_idColumn" msprop:Generator_UserColumnName="publishing_hpuse_id" type="xs:int" />
              <xs:element name="author_id" msprop:Generator_ColumnVarNameInTable="columnauthor_id" msprop:Generator_ColumnPropNameInRow="author_id" msprop:Generator_ColumnPropNameInTable="author_idColumn" msprop:Generator_UserColumnName="author_id" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="book_author" msprop:Generator_TableClassName="book_authorDataTable" msprop:Generator_TableVarName="tablebook_author" msprop:Generator_TablePropName="book_author" msprop:Generator_RowDeletingName="book_authorRowDeleting" msprop:Generator_RowChangingName="book_authorRowChanging" msprop:Generator_RowEvHandlerName="book_authorRowChangeEventHandler" msprop:Generator_RowDeletedName="book_authorRowDeleted" msprop:Generator_UserTableName="book_author" msprop:Generator_RowChangedName="book_authorRowChanged" msprop:Generator_RowEvArgName="book_authorRowChangeEvent" msprop:Generator_RowClassName="book_authorRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="author_id" msprop:Generator_ColumnVarNameInTable="columnauthor_id" msprop:Generator_ColumnPropNameInRow="author_id" msprop:Generator_ColumnPropNameInTable="author_idColumn" msprop:Generator_UserColumnName="author_id" type="xs:int" />
              <xs:element name="book_id" msprop:Generator_ColumnVarNameInTable="columnbook_id" msprop:Generator_ColumnPropNameInRow="book_id" msprop:Generator_ColumnPropNameInTable="book_idColumn" msprop:Generator_UserColumnName="book_id" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="category" msprop:Generator_TableClassName="categoryDataTable" msprop:Generator_TableVarName="tablecategory" msprop:Generator_TablePropName="category" msprop:Generator_RowDeletingName="categoryRowDeleting" msprop:Generator_RowChangingName="categoryRowChanging" msprop:Generator_RowEvHandlerName="categoryRowChangeEventHandler" msprop:Generator_RowDeletedName="categoryRowDeleted" msprop:Generator_UserTableName="category" msprop:Generator_RowChangedName="categoryRowChanged" msprop:Generator_RowEvArgName="categoryRowChangeEvent" msprop:Generator_RowClassName="categoryRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CategoryBook" msprop:Generator_TableClassName="CategoryBookDataTable" msprop:Generator_TableVarName="tableCategoryBook" msprop:Generator_TablePropName="CategoryBook" msprop:Generator_RowDeletingName="CategoryBookRowDeleting" msprop:Generator_RowChangingName="CategoryBookRowChanging" msprop:Generator_RowEvHandlerName="CategoryBookRowChangeEventHandler" msprop:Generator_RowDeletedName="CategoryBookRowDeleted" msprop:Generator_UserTableName="CategoryBook" msprop:Generator_RowChangedName="CategoryBookRowChanged" msprop:Generator_RowEvArgName="CategoryBookRowChangeEvent" msprop:Generator_RowClassName="CategoryBookRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CategoryID" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" msprop:Generator_UserColumnName="CategoryID" type="xs:int" />
              <xs:element name="BookID" msprop:Generator_ColumnVarNameInTable="columnBookID" msprop:Generator_ColumnPropNameInRow="BookID" msprop:Generator_ColumnPropNameInTable="BookIDColumn" msprop:Generator_UserColumnName="BookID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="publishing_house" msprop:Generator_TableClassName="publishing_houseDataTable" msprop:Generator_TableVarName="tablepublishing_house" msprop:Generator_TablePropName="publishing_house" msprop:Generator_RowDeletingName="publishing_houseRowDeleting" msprop:Generator_RowChangingName="publishing_houseRowChanging" msprop:Generator_RowEvHandlerName="publishing_houseRowChangeEventHandler" msprop:Generator_RowDeletedName="publishing_houseRowDeleted" msprop:Generator_UserTableName="publishing_house" msprop:Generator_RowChangedName="publishing_houseRowChanged" msprop:Generator_RowEvArgName="publishing_houseRowChangeEvent" msprop:Generator_RowClassName="publishing_houseRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_UserColumnName="title" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="purchase" msprop:Generator_TableClassName="purchaseDataTable" msprop:Generator_TableVarName="tablepurchase" msprop:Generator_TablePropName="purchase" msprop:Generator_RowDeletingName="purchaseRowDeleting" msprop:Generator_RowChangingName="purchaseRowChanging" msprop:Generator_RowEvHandlerName="purchaseRowChangeEventHandler" msprop:Generator_RowDeletedName="purchaseRowDeleted" msprop:Generator_UserTableName="purchase" msprop:Generator_RowChangedName="purchaseRowChanged" msprop:Generator_RowEvArgName="purchaseRowChangeEvent" msprop:Generator_RowClassName="purchaseRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="purchase_date" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnpurchase_date" msprop:Generator_ColumnPropNameInRow="purchase_date" msprop:Generator_ColumnPropNameInTable="purchase_dateColumn" msprop:Generator_UserColumnName="purchase_date" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="user_account_id" msprop:Generator_ColumnVarNameInTable="columnuser_account_id" msprop:Generator_ColumnPropNameInRow="user_account_id" msprop:Generator_ColumnPropNameInTable="user_account_idColumn" msprop:Generator_UserColumnName="user_account_id" type="xs:int" />
              <xs:element name="delivery_adress_id" msprop:Generator_ColumnVarNameInTable="columndelivery_adress_id" msprop:Generator_ColumnPropNameInRow="delivery_adress_id" msprop:Generator_ColumnPropNameInTable="delivery_adress_idColumn" msprop:Generator_UserColumnName="delivery_adress_id" type="xs:int" />
              <xs:element name="total_prise" msprop:Generator_ColumnVarNameInTable="columntotal_prise" msprop:Generator_ColumnPropNameInRow="total_prise" msprop:Generator_ColumnPropNameInTable="total_priseColumn" msprop:Generator_UserColumnName="total_prise" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="purchase_item" msprop:Generator_TableClassName="purchase_itemDataTable" msprop:Generator_TableVarName="tablepurchase_item" msprop:Generator_TablePropName="purchase_item" msprop:Generator_RowDeletingName="purchase_itemRowDeleting" msprop:Generator_RowChangingName="purchase_itemRowChanging" msprop:Generator_RowEvHandlerName="purchase_itemRowChangeEventHandler" msprop:Generator_RowDeletedName="purchase_itemRowDeleted" msprop:Generator_UserTableName="purchase_item" msprop:Generator_RowChangedName="purchase_itemRowChanged" msprop:Generator_RowEvArgName="purchase_itemRowChangeEvent" msprop:Generator_RowClassName="purchase_itemRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="book_id" msprop:Generator_ColumnVarNameInTable="columnbook_id" msprop:Generator_ColumnPropNameInRow="book_id" msprop:Generator_ColumnPropNameInTable="book_idColumn" msprop:Generator_UserColumnName="book_id" type="xs:int" />
              <xs:element name="purchase_id" msprop:Generator_ColumnVarNameInTable="columnpurchase_id" msprop:Generator_ColumnPropNameInRow="purchase_id" msprop:Generator_ColumnPropNameInTable="purchase_idColumn" msprop:Generator_UserColumnName="purchase_id" type="xs:int" />
              <xs:element name="quantity" msprop:Generator_ColumnVarNameInTable="columnquantity" msprop:Generator_ColumnPropNameInRow="quantity" msprop:Generator_ColumnPropNameInTable="quantityColumn" msprop:Generator_UserColumnName="quantity" type="xs:int" minOccurs="0" />
              <xs:element name="items_prise" msprop:Generator_ColumnVarNameInTable="columnitems_prise" msprop:Generator_ColumnPropNameInRow="items_prise" msprop:Generator_ColumnPropNameInTable="items_priseColumn" msprop:Generator_UserColumnName="items_prise" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="user_account" msprop:Generator_TableClassName="user_accountDataTable" msprop:Generator_TableVarName="tableuser_account" msprop:Generator_TablePropName="user_account" msprop:Generator_RowDeletingName="user_accountRowDeleting" msprop:Generator_RowChangingName="user_accountRowChanging" msprop:Generator_RowEvHandlerName="user_accountRowChangeEventHandler" msprop:Generator_RowDeletedName="user_accountRowDeleted" msprop:Generator_UserTableName="user_account" msprop:Generator_RowChangedName="user_accountRowChanged" msprop:Generator_RowEvArgName="user_accountRowChangeEvent" msprop:Generator_RowClassName="user_accountRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="user_name" msprop:Generator_ColumnVarNameInTable="columnuser_name" msprop:Generator_ColumnPropNameInRow="user_name" msprop:Generator_ColumnPropNameInTable="user_nameColumn" msprop:Generator_UserColumnName="user_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="254" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password_salt" msprop:Generator_ColumnVarNameInTable="columnpassword_salt" msprop:Generator_ColumnPropNameInRow="password_salt" msprop:Generator_ColumnPropNameInTable="password_saltColumn" msprop:Generator_UserColumnName="password_salt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password_hash_algorithm" msprop:Generator_ColumnVarNameInTable="columnpassword_hash_algorithm" msprop:Generator_ColumnPropNameInRow="password_hash_algorithm" msprop:Generator_ColumnPropNameInTable="password_hash_algorithmColumn" msprop:Generator_UserColumnName="password_hash_algorithm" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:adress" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="author_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:author" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="book_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:book" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="category_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:category" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="publishing_house_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:publishing_house" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="purchase_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:purchase" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="user_account_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:user_account" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_book_publishing_house" msdata:parent="publishing_house" msdata:child="book" msdata:parentkey="id" msdata:childkey="publishing_hpuse_id" msprop:Generator_UserChildTable="book" msprop:Generator_ChildPropName="GetbookRows" msprop:Generator_UserRelationName="FK_book_publishing_house" msprop:Generator_RelationVarName="relationFK_book_publishing_house" msprop:Generator_UserParentTable="publishing_house" msprop:Generator_ParentPropName="publishing_houseRow" />
      <msdata:Relationship name="FK_book_author_author" msdata:parent="author" msdata:child="book_author" msdata:parentkey="id" msdata:childkey="author_id" msprop:Generator_UserChildTable="book_author" msprop:Generator_ChildPropName="Getbook_authorRows" msprop:Generator_UserRelationName="FK_book_author_author" msprop:Generator_ParentPropName="authorRow" msprop:Generator_RelationVarName="relationFK_book_author_author" msprop:Generator_UserParentTable="author" />
      <msdata:Relationship name="FK_book_author_book" msdata:parent="book" msdata:child="book_author" msdata:parentkey="id" msdata:childkey="book_id" msprop:Generator_UserChildTable="book_author" msprop:Generator_ChildPropName="Getbook_authorRows" msprop:Generator_UserRelationName="FK_book_author_book" msprop:Generator_ParentPropName="bookRow" msprop:Generator_RelationVarName="relationFK_book_author_book" msprop:Generator_UserParentTable="book" />
      <msdata:Relationship name="FK_CategoryBook_book" msdata:parent="book" msdata:child="CategoryBook" msdata:parentkey="id" msdata:childkey="BookID" msprop:Generator_UserChildTable="CategoryBook" msprop:Generator_ChildPropName="GetCategoryBookRows" msprop:Generator_UserRelationName="FK_CategoryBook_book" msprop:Generator_ParentPropName="bookRow" msprop:Generator_RelationVarName="relationFK_CategoryBook_book" msprop:Generator_UserParentTable="book" />
      <msdata:Relationship name="FK_CategoryBook_category" msdata:parent="category" msdata:child="CategoryBook" msdata:parentkey="id" msdata:childkey="CategoryID" msprop:Generator_UserChildTable="CategoryBook" msprop:Generator_ChildPropName="GetCategoryBookRows" msprop:Generator_UserRelationName="FK_CategoryBook_category" msprop:Generator_ParentPropName="categoryRow" msprop:Generator_RelationVarName="relationFK_CategoryBook_category" msprop:Generator_UserParentTable="category" />
      <msdata:Relationship name="FK_purchase_adress" msdata:parent="adress" msdata:child="purchase" msdata:parentkey="id" msdata:childkey="delivery_adress_id" msprop:Generator_UserChildTable="purchase" msprop:Generator_ChildPropName="GetpurchaseRows" msprop:Generator_UserRelationName="FK_purchase_adress" msprop:Generator_ParentPropName="adressRow" msprop:Generator_RelationVarName="relationFK_purchase_adress" msprop:Generator_UserParentTable="adress" />
      <msdata:Relationship name="FK_purchase_user_account" msdata:parent="user_account" msdata:child="purchase" msdata:parentkey="id" msdata:childkey="user_account_id" msprop:Generator_UserChildTable="purchase" msprop:Generator_ChildPropName="GetpurchaseRows" msprop:Generator_UserRelationName="FK_purchase_user_account" msprop:Generator_RelationVarName="relationFK_purchase_user_account" msprop:Generator_UserParentTable="user_account" msprop:Generator_ParentPropName="user_accountRow" />
      <msdata:Relationship name="FK_purchase_item_book" msdata:parent="book" msdata:child="purchase_item" msdata:parentkey="id" msdata:childkey="book_id" msprop:Generator_UserChildTable="purchase_item" msprop:Generator_ChildPropName="Getpurchase_itemRows" msprop:Generator_UserRelationName="FK_purchase_item_book" msprop:Generator_ParentPropName="bookRow" msprop:Generator_RelationVarName="relationFK_purchase_item_book" msprop:Generator_UserParentTable="book" />
      <msdata:Relationship name="FK_purchase_item_purchase" msdata:parent="purchase" msdata:child="purchase_item" msdata:parentkey="id" msdata:childkey="purchase_id" msprop:Generator_UserChildTable="purchase_item" msprop:Generator_ChildPropName="Getpurchase_itemRows" msprop:Generator_UserRelationName="FK_purchase_item_purchase" msprop:Generator_ParentPropName="purchaseRow" msprop:Generator_RelationVarName="relationFK_purchase_item_purchase" msprop:Generator_UserParentTable="purchase" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>